package com.bw.dao;

import com.alibaba.fastjson.JSONObject;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TrafficDao {
    @Select("select ch , sum(uv_ct) uc_count from dws_traffic_vc_ch_ar_is_new_page_view_window\n" +
            "where toYYYYMMDD(stt)=#{chio} group by ch")
    public List<JSONObject> jieshi(int chio);
}
